SELECT Id FROM new_searchtable
where town = 'Newbury' and state='NH' and (type = 'R' or type ='O')
AND list_price BETWEEN '1000000' AND '99999999'
ORDER BY list_price Desc
Newbury NH Homes page 5
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:On the waters and with a gentle approach to the lake, this amazing Lake Sunapee property is available for the first time since 1959. Take a step back in time to this early 1900s seasonal cottage with 100 +/- feet of waterfront and a private dock. This 4-bedroom, 2-bathroom cottage has ample room for friends and family to stay and spend the summer months out on the lake or sitting on the screened-in porch taking in the fresh air and wildlife that surrounds with amazing views of Mount Sunapee and stunning sunsets. This is the perfect spot to go out on your boat, kayak or paddle board, go for a swim and go fishing. Lake Sunapee spans 4,155 acres of pristine glacial water and is surrounded by the towns of Sunapee, New London and Newbury, one of the cleanest lakes in New Hampshire. There are many options with the property, including rebuilding and creating the home of your dreams. Close to many other local lakes and ponds, golf courses, hiking trails, and so much more. Just minutes to Mount Sunapee Resort for your winter and summer fun, plus only 30 minutes to Concord where you can find an abundance of shopping, dining, theater, coffee shops and amenities. Only two hours to Boston. This is what lake life should be all about.